<?php
  require_once('db_connection.php');

  $query_create_table =
  "CREATE TABLE IF NOT EXISTS `users` (
    `id` INT AUTO_INCREMENT,
    `name` VARCHAR(80),
    `email` VARCHAR(100),
    `password` VARCHAR(32),
    `added_date` DATETIME,
    `modified_date` TIMESTAMP,
    `status` ENUM('0','1'),
    PRIMARY KEY (`id`)
  )";
  mysql_query($query_create_table) or die(mysql_error());
/////////////////////////////////////////////////////////////////
  $query = "DESC `users`";
  $result  = mysql_query($query) or die(mysql_error());
var_dump($result);
  while($ans = mysql_fetch_assoc($result)){
    $data[] = $ans;
    //print_r($ans);
  }
  while($ans = mysql_fetch_assoc($result)){
    print_r($ans);
  }
  foreach($data as $key=>$val){
    print_r($val);
  }
var_dump($result);
